Drag and Drop

You can map source metadata with target metadata and create mapping specifications using the drag and drop method. This method is useful even when source column names are different from target column names. After mapping source to target, you can set the target update strategy and enter a description about the strategy.

Creating Mapping Specifications

To create mapping specifications using drag and drop method, follow these steps:

  1. In the Workspace Mappings pane, click a map.

    2. By default, the Mapping Specification tab opens.

  2. Click .

    3. You can now edit the Mapping Specification grid.

  3. Drag source table or column from the Metadata Catalogue pane and drop in the Mapping Specification grid.

    4. Ensure that you drop source tables or columns under the respective columns.

    You cannot drop source systems or environments in the Mapping Specification grid.

  4. Drag target table or column from the Metadata Catalogue pane and drop in the Mapping Specification grid.

    5. Ensure that you drop target tables or columns under the respective columns.

    You cannot drop target systems or environments in the Mapping Specification grid.

  5. Click .

    6. The mapping specification is saved.

Setting Target Update Strategy

To set the target update strategy, follow these steps:

  1. Expand the Additional Mapping Information pane.

    2. This pane is available at bottom of the central pane when you click a map in the Workspace Mappings pane.

  2. Click the Target Update Strategy tab.
  3. Click .
  4. Click the required strategy, enter Update Strategy Description, and click .

The target update strategy is set.

You can enrich a mapping specification by:

After creating a mapping specification, you can analyze a mapping specification. Analyzing mapping specifications involves:

  • Generating virtual preview of target
  • Previewing data
  • Performing table gap analysis
  • Performing column gap analysis
  • Running impact analysis
  • Running lineage analysis
  • Running end to end lineage
  • Opening business view
  • Viewing mapping statistics